﻿using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using eTMS.Controllers.NganhHocService;
using eTMS.Controllers;
using eTMS.Commons;
namespace eTMS.Forms.ManageList{
    public partial class FrmNganhHoc : eTMS.Controls.BaseForm
    {
        public FrmNganhHoc()
        {
            InitializeComponent();
        }
        #region Variables
        private NganhHocController controller = new NganhHocController();
        #endregion
        #region Screen Functions
        //Load All lable text
        private void LoadLanguage(){
			this.Text=NganhHocStringMapping.NganhHoc;
			this.labelFormTitle.Text=Constants.APP_ADMINISTRATION+" "+NganhHocStringMapping.NganhHoc;
			this.groupBoxDetail.Text=Constants.APP_DETAIL;
			this.groupBoxList.Text=Constants.APP_LIST;
			this.ColumnSTT.HeaderText=Constants.APP_INDEX;
			labelMaNganhHoc.Text=NganhHocStringMapping.MaNganhHoc;
			ColumnMaNganhHoc.HeaderText=NganhHocStringMapping.MaNganhHoc;
			labelTenNganhHoc.Text=NganhHocStringMapping.TenNganhHoc;
			ColumnTenNganhHoc.HeaderText=NganhHocStringMapping.TenNganhHoc;
			labelMoTaNganhHoc.Text=NganhHocStringMapping.MoTaNganhHoc;
			ColumnMoTaNganhHoc.HeaderText=NganhHocStringMapping.MoTaNganhHoc;
			labelHeDaoTao_ID.Text=NganhHocStringMapping.HeDaoTao_ID;
			labelKhoa_ID.Text=NganhHocStringMapping.Khoa_ID;
		    //Search
		    this.groupBoxFilter.Text=Constants.APP_SEARCH;
			cbkMaNganhHocFilterExact.Text=Constants.APP_SEARCH_EXACT;
			labelMaNganhHocFilter.Text=NganhHocStringMapping.MaNganhHoc;
			cbkTenNganhHocFilterExact.Text=Constants.APP_SEARCH_EXACT;
			labelTenNganhHocFilter.Text=NganhHocStringMapping.TenNganhHoc;
			cbkMoTaNganhHocFilterExact.Text=Constants.APP_SEARCH_EXACT;
			labelMoTaNganhHocFilter.Text=NganhHocStringMapping.MoTaNganhHoc;
			labelHeDaoTao_IDFilter.Text=NganhHocStringMapping.HeDaoTao_ID;
			labelKhoa_IDFilter.Text=NganhHocStringMapping.Khoa_ID;
		    //end
        }
        //Get entity selected from datagrid
        private NganhHocEntity GetObject(){
		    NganhHocEntity o=controller.MapDataRowToObject(((DataRowView)gridData.SelectedRows[0].DataBoundItem).Row);
		    return o;
        }        
        //Get entites selected from datagrid
        private List<DataRow> GetSelectedDataRows(){
		    List<DataRow> ls=new List<DataRow>();
            for(int i=0;i<gridData.SelectedRows.Count;i++){
                ls.Add(GetDataRow(gridData.SelectedRows[i].Index));
            }
		    return ls;
        }
        //Get the selected data row in datagrid
        private DataRow GetSelectedDataRow(){
			DataRow row=GetDataRow(gridData.SelectedRows[0].Index);
		    return row;
        }
         //Get the selected data row in datagrid
        private DataRow GetDataRow(int index){
			DataRow row=((DataRowView)gridData.Rows[index].DataBoundItem).Row;
		    return row;
        }
        //Reset all textbox
        private void ClearScreen(){
			txtMaNganhHoc.Text="";
			txtTenNganhHoc.Text="";
			txtMoTaNganhHoc.Text="";
			errorProviderData.Clear();
        }
        //Lock-Unlock control in screen
        private void LockScreen(bool IsLocked){            
            ucCommand.LockControl(IsLocked);
			txtMaNganhHoc.ReadOnly = IsLocked;
			txtTenNganhHoc.ReadOnly = IsLocked;
			txtMoTaNganhHoc.ReadOnly = IsLocked;
			txtHeDaoTao_ID.ReadOnly = IsLocked;
			txtKhoa_ID.ReadOnly = IsLocked;
        }
        //Copy data from control in screen to object
        private void CopyFromSreen(NganhHocEntity o){
			 o.MaNganhHoc=Convert.ToString(txtMaNganhHoc.Text);
			 o.TenNganhHoc=Convert.ToString(txtTenNganhHoc.Text);
			 o.MoTaNganhHoc=Convert.ToString(txtMoTaNganhHoc.Text);
			 o.HeDaoTao_ID=Convert.ToInt32(txtHeDaoTao_ID.SelectedValue);
			 o.Khoa_ID=Convert.ToInt32(txtKhoa_ID.SelectedValue);
        }
        //Bind data from object to control in screen
        private void CopyToSreen(NganhHocEntity o){
		    if(!o.IsNullMaNganhHoc){
			txtMaNganhHoc.Text=Convert.ToString(o.MaNganhHoc);
		    }
		    if(!o.IsNullTenNganhHoc){
			txtTenNganhHoc.Text=Convert.ToString(o.TenNganhHoc);
		    }
		    if(!o.IsNullMoTaNganhHoc){
			txtMoTaNganhHoc.Text=Convert.ToString(o.MoTaNganhHoc);
		    }
            if(!o.IsNullHeDaoTao_ID){
				txtHeDaoTao_ID.SelectedValue=o.HeDaoTao_ID;
			}
			else{
				txtHeDaoTao_ID.SelectedValue=null;
			}
            if(!o.IsNullKhoa_ID){
				txtKhoa_ID.SelectedValue=o.Khoa_ID;
			}
			else{
				txtKhoa_ID.SelectedValue=null;
			}
        }
        //Validate all data from control in screen before Save data
        protected bool ValidateScreen(){
		    bool result=true;
			if(txtMaNganhHoc.Text.Trim()==""){
				txtMaNganhHoc.Focus();
				errorProviderData.SetError (txtMaNganhHoc, Constants.MSS_ERROR_TEXT);
				result=false;
			}			
			else{
				errorProviderData.SetError(txtMaNganhHoc, "");
			}			
			if(txtTenNganhHoc.Text.Trim()==""){
				txtTenNganhHoc.Focus();
				errorProviderData.SetError (txtTenNganhHoc, Constants.MSS_ERROR_TEXT);
				result=false;
			}			
			else{
				errorProviderData.SetError(txtTenNganhHoc, "");
			}			
			if(((txtHeDaoTao_ID.SelectedIndex<=0)&&((txtHeDaoTao_ID.IsAddChooseItem)||(txtHeDaoTao_ID.IsAddAllItem)))||(txtHeDaoTao_ID.SelectedIndex<0)){
				txtHeDaoTao_ID.Focus();
				errorProviderData.SetError(txtHeDaoTao_ID, Constants.MSS_ERROR_DROPDOWN);
				result=false;
			}
			else{
				errorProviderData.SetError (txtHeDaoTao_ID, "");
			}
			if(((txtKhoa_ID.SelectedIndex<=0)&&((txtKhoa_ID.IsAddChooseItem)||(txtKhoa_ID.IsAddAllItem)))||(txtKhoa_ID.SelectedIndex<0)){
				txtKhoa_ID.Focus();
				errorProviderData.SetError(txtKhoa_ID, Constants.MSS_ERROR_DROPDOWN);
				result=false;
			}
			else{
				errorProviderData.SetError (txtKhoa_ID, "");
			}
		    if(!result){
				ShowInfo(Constants.MSS_REQUIRE_FIELD);
		    }
		    if(result){
				//Check if exists MaNganhHoc				
				bool existsMaNganhHoc=controller.CheckExistsMaNganhHoc(txtMaNganhHoc.Text);
				bool editexists=false;
				if(Flag==ACTIONENUM.Edit){
					DataRow row = GetSelectedDataRow();
					string newVal=txtMaNganhHoc.Text;
					editexists=Convert.ToString(row["MaNganhHoc"])!=Convert.ToString(newVal);
				}
				if(existsMaNganhHoc&&((Flag==ACTIONENUM.AddNew)||editexists)){
					result = false; 					
					errorProviderData.SetError(txtMaNganhHoc,Constants.MSS_ERROR_DATA_UNIQUE);
					txtMaNganhHoc.Focus();
					ShowInfo(Constants.MSS_ERROR_EXISTS_DATA);
				}
				else
				{
					errorProviderData.SetError (txtMaNganhHoc, "");
				}
			}
		    return result;
        }
        //Copy data from selected object to control in screen
        private void BindInfo(){
			if (gridData.SelectedRows.Count == 0) return;
			if(gridData.SelectedRows[0].Index<gridData.Rows.Count){
				NganhHocEntity o=GetObject();	
				CopyToSreen(o);
		    }
        }    
        #endregion
        #region Business
        //AddNew data to database
        private bool AddNewData()
        {
			bool rval=false;
            controller.ResetObject();		
		    CopyFromSreen(controller.NganhHocObject);		    
            rval=controller.AddNew();
            if(rval){
				DataRow row=controller.Table.NewRow();
				row["STT"]=controller.Table.Rows.Count+1;
				controller.MapObjectToDataRow(row);
				controller.Table.Rows.Add(row);
				gridData.DataSource=null;
				gridData.DataSource=controller.Table;
            }
            return rval;
        }
        //Update data to database
        private bool UpdateData()
        {      
			DataRow row=GetSelectedDataRow();
            controller.LoadObject((Int32)row["NganhHoc_ID"]);		
		    CopyFromSreen(controller.NganhHocObject);
		    bool rval=controller.Update();
            if(rval){
				controller.MapObjectToDataRow(row);
				gridData.InvalidateRow(gridData.SelectedRows[0].Index);
            }
            return rval;
        }
        //Delete data from database
        private bool DeleteData()
        {
            List<DataRow> ls=GetSelectedDataRows();
            if(ls.Count==0)return false;  
            bool rval=true; 
            try{
                gridData.DataSource = null;
				foreach(DataRow row in ls){
					if(controller.DeleteByID((Int32)row["NganhHoc_ID"])){
						 this.controller.Table.Rows.Remove(row);
					}	
					else
					{
						rval=false;
					}				
				}
				this.controller.ResetTableIndex();
                gridData.DataSource = this.controller.Table;
            }
            catch{
				return false;
            }
            return true;
        }        
        #endregion
        #region DataBinding 
        //Bind data to datagrid
        private void LoadData(){
            gridData.AutoGenerateColumns = false;
            gridData.DataSource=controller.Table;     
            gridData.AutoResizeColumns();       
        }
        #endregion
        #region Windows Control EventHandlers
        private void FrmNganhHoc_Load(object sender, EventArgs e)
        {
            KhoaController.LoadAllKhoa(false);
            txtKhoa_ID.BindData();
            txtKhoa_IDFilter.BindData();
			LoadLanguage();
            LoadData();
            LockScreen(true);
            this.groupBoxFilter.ToggleCollapsed();
        }       
		private void gridData_RowEnter(object sender, DataGridViewCellEventArgs e)
        {
			BindInfo();
        }   
        private void ucCommand_OnAddNew(object sender, EventArgs e)
        {
			ClearScreen();
            LockScreen(false);
            Flag=ACTIONENUM.AddNew;
			txtMaNganhHoc.Focus();
        }
        private void ucCommand_OnDelete(object sender, EventArgs e)
        {
			if(gridData.SelectedRows.Count==0){
                ShowInfo(Constants.MSS_CHOOSERECORD_REQUIRE);
                return;
            }
            if(!Confirm(Constants.MSS_CONFIRM_DELETE))return;
            DeleteData();
			this.gridData.Focus();
        }
        private void ucCommand_OnEdit(object sender, EventArgs e)
        {
			if(gridData.SelectedRows.Count==0){
                ShowInfo(Constants.MSS_CHOOSERECORD_REQUIRE);
                return;
            }
            LockScreen(false);
            Flag=ACTIONENUM.Edit;
			txtMaNganhHoc.Focus();
        }
        private void ucCommand_OnSave(object sender, EventArgs e)
        {
			if(!ValidateScreen())
				return;
            if(Flag==ACTIONENUM.Edit){
                if(UpdateData()){
                    ShowInfo(Constants.MSS_SAVE_SUCCESS);
                }
                else{
                    ShowWarning(Constants.MSS_SAVE_FAILE);
                }
                gridData.Focus();
            }
            else{
                if(AddNewData()){
                    ShowInfo(Constants.MSS_SAVE_SUCCESS);
                }
                else{
                    ShowWarning(Constants.MSS_SAVE_FAILE);
                }
            }
            LockScreen(true);
            Flag=ACTIONENUM.None;
        }
        private void ucCommand_OnSkip(object sender, EventArgs e)
        {
			LockScreen(true);  
			if(Flag==ACTIONENUM.AddNew){			
				ClearScreen();    
				ucCommand.SetFocusAddNew();
			}
			else if(Flag==ACTIONENUM.Edit){				
				BindInfo();
				this.gridData.Focus();
			}      
            Flag=ACTIONENUM.None;
        }
        #endregion   
        #region Filters
        private string GetFilter(){
			string strFilter="";
			if(txtMaNganhHocFilter.Text.Trim()!=""){
				if(cbkMaNganhHocFilterExact.Checked){
					strFilter+=" AND MaNganhHoc='"+txtMaNganhHocFilter.Text.Trim()+"'";
				}
				else{
					strFilter+=" AND MaNganhHoc LIKE '%"+txtMaNganhHocFilter.Text.Trim()+"%'";
				}
			}	
			if(txtTenNganhHocFilter.Text.Trim()!=""){
				if(cbkTenNganhHocFilterExact.Checked){
					strFilter+=" AND TenNganhHoc='"+txtTenNganhHocFilter.Text.Trim()+"'";
				}
				else{
					strFilter+=" AND TenNganhHoc LIKE '%"+txtTenNganhHocFilter.Text.Trim()+"%'";
				}
			}	
			if(txtMoTaNganhHocFilter.Text.Trim()!=""){
				if(cbkMoTaNganhHocFilterExact.Checked){
					strFilter+=" AND MoTaNganhHoc='"+txtMoTaNganhHocFilter.Text.Trim()+"'";
				}
				else{
					strFilter+=" AND MoTaNganhHoc LIKE '%"+txtMoTaNganhHocFilter.Text.Trim()+"%'";
				}
			}	
			if(txtHeDaoTao_IDFilter.SelectedIndex>0){
				strFilter+=" AND HeDaoTao_ID='"+txtHeDaoTao_IDFilter.SelectedValue.ToString()+"'";	
			}
			if(txtKhoa_IDFilter.SelectedIndex>0){
				strFilter+=" AND Khoa_ID='"+txtKhoa_IDFilter.SelectedValue.ToString()+"'";	
			}
			if(strFilter.Length>0)
				strFilter=strFilter.Substring(4);
			return strFilter;
		}
		private void FilterData(){		
            gridData.ClearSelection();
			controller.Table.DefaultView.RowFilter=GetFilter();
		}
        private void btnSearch_Click(object sender, EventArgs e)
        {
			FilterData();
        }
        #endregion   
    }
}
